UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Hr4IcRBorhtBVkTQgHizCM3YO3b/OPGBqK4LywQMiEc='
WHERE
key_id = 'bdc7c0cfd70e563bdf0aeb86840a80ee58efc485a877c18e454b547a025d5aa9'
AND (
token = 'Hr4IcRBorhtBVkTQgHizCM3YO3b/OPGBqK4LywQMiEc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)