UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'g5YuAFW5VnPnIyUP/WaREbj5eiNHarwsGfiAAKOcuYo='
WHERE
key_id = 'df9d66492fdcd43884cb7bef6041d35972874a1c4e6741f8a95ecf5bbe1a69b7'
AND (
token = 'g5YuAFW5VnPnIyUP/WaREbj5eiNHarwsGfiAAKOcuYo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)