UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4uGWq7mbXcIfFpkmJlj1wiTHG3hkotcO+haHPPD7LqU='
WHERE
key_id = '21c7ddb87032426717c6356c8088e71be56e5f4415a6780108f2301592741757'
AND (
token = '4uGWq7mbXcIfFpkmJlj1wiTHG3hkotcO+haHPPD7LqU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)