UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SZKYmG5MRMw4UvZ9NQiVhG14lrgwvG3lKF0vAaJDWuA='
WHERE
key_id = '16afa8e657a2b6092789c21088b040bc812a3c5312ddd991fc9908df898c11b5'
AND (
token = 'SZKYmG5MRMw4UvZ9NQiVhG14lrgwvG3lKF0vAaJDWuA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)