UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'niL4tJVbv2kI2ZM6YHsvYXd49a+vQyemepTnxox6GvU='
WHERE
key_id = '7ae5e779398da4b246041e280f841b933127788ca95953941d5d41c41491a135'
AND (
token = 'niL4tJVbv2kI2ZM6YHsvYXd49a+vQyemepTnxox6GvU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)