UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'a6KCjI/MJ73kLnNHMc/LDTBXwAFDjlbxytZm0JS2laA='
WHERE
key_id = 'e4409bb304e315319a9ee43d6c99b7a907cb8bfd5c56bd6f6e71845f5914bf1c'
AND (
token = 'a6KCjI/MJ73kLnNHMc/LDTBXwAFDjlbxytZm0JS2laA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)