UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YK7plLhitl11LiVYDfzYMGrACoW7hJTFZhTCJe60T84='
WHERE
key_id = 'dead1e3ecebd1d8c63c182e064ea652a7871dabcb0ffc2ddf0dfd4170375f1fd'
AND (
token = 'YK7plLhitl11LiVYDfzYMGrACoW7hJTFZhTCJe60T84='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)