UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nDLF2ZbLsi4ou2fpdz10LqLgXNS8tXgEGMxJbjyimoU='
WHERE
key_id = '7acf4065100c9d4a031bb27f047d5b7fc312589f3dc75d18b9ded6b72c36aa97'
AND (
token = 'nDLF2ZbLsi4ou2fpdz10LqLgXNS8tXgEGMxJbjyimoU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)