UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7a20w3B72SJnPTvSAtbh7K/DoD/qYlxEV98rftsMLdU='
WHERE
key_id = '770b13aff313578da9c765d854152317fc7f8dd32b9ea82122343117b24efa2a'
AND (
token = '7a20w3B72SJnPTvSAtbh7K/DoD/qYlxEV98rftsMLdU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)