UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TSnPctM2XJuahQYRKkYtEIB8k6Qi88N4qLouq2fzX9E='
WHERE
key_id = 'c1c67152c9b25724cdf4178ba026d60b9ee7b0a0270327d2ca4726a93b4ff4b8'
AND (
token = 'TSnPctM2XJuahQYRKkYtEIB8k6Qi88N4qLouq2fzX9E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)