UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3FiOdYshlBJUt0YEO72RKkn7cGPp9nwhRjeAHcja3r4='
WHERE
key_id = 'cf75961f8510e664edf4b17b8da869c701d1312d839905af96a40b90fa96fb58'
AND (
token = '3FiOdYshlBJUt0YEO72RKkn7cGPp9nwhRjeAHcja3r4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)