UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ffog5jkospNLvbg4cx8mafgFtLDMpbiGJxwvTgAkBwU='
WHERE
key_id = '28defd1c300a5a29fcc761e3c6ddc9ca28015d8023278e80b3e24aba62b05169'
AND (
token = 'ffog5jkospNLvbg4cx8mafgFtLDMpbiGJxwvTgAkBwU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)