UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+4d7kZMkYwzU1LNGqbp9UeERuiwzphvFIVCh837OBtM='
WHERE
key_id = '8225a30eaa84f3bbe415713a4a8d43d0d80ead3aaa45b8a0938b1895ba223976'
AND (
token = '+4d7kZMkYwzU1LNGqbp9UeERuiwzphvFIVCh837OBtM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)