UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ylE9rmkft+VeTba0iKT4ntmI9sgAHAm+G+kRV4W6lNU='
WHERE
key_id = 'b9eddd8e75e04d3c5a0ec47b7c79d60f563c880c9a76c22cbdb585a87c1e063d'
AND (
token = 'ylE9rmkft+VeTba0iKT4ntmI9sgAHAm+G+kRV4W6lNU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)