UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '78tlqbXYtKo6ViuNQoOkpdh5rmF4PsoC0R5XkNyXocw='
WHERE
key_id = '474c79c267ffe73998d2d671c519095fa5792ed66ae583c0a209912b765f54b3'
AND (
token = '78tlqbXYtKo6ViuNQoOkpdh5rmF4PsoC0R5XkNyXocw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)