UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'J78tfGiv/F1j5KE2OzaLkCY4F5FGlmciyC6OjHIzAuU='
WHERE
key_id = '227f053faae0eabc3a7c7e955ea5ef7da9f3b3df87533bba0763ece278cbf114'
AND (
token = 'J78tfGiv/F1j5KE2OzaLkCY4F5FGlmciyC6OjHIzAuU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)