UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zqzGC9uwNkDTJF3tSb58Qedznv9ZzYB+I4MyW1ySiQ0='
WHERE
key_id = '527563cce6ceb60d492f79aa07f6d51aefd300428332aa4f873a7e6a8de28f20'
AND (
token = 'zqzGC9uwNkDTJF3tSb58Qedznv9ZzYB+I4MyW1ySiQ0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)