UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9vnZONuWwfrf6Y7eXp7qU1SMzpUYbjPeZkddIEI33yQ='
WHERE
key_id = 'f7045707f7e86333687772311d165c40a851bf6c21100807b742c357cbb5c257'
AND (
token = '9vnZONuWwfrf6Y7eXp7qU1SMzpUYbjPeZkddIEI33yQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)