UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KAp8dn7CzyxXR3/VnyW8PsmtnMpoUTo+qn5BufjZ0C4='
WHERE
key_id = '4a992c4f703bf11c20660b57faeccbd9d1568d4e5e302ab42be234d3d874a037'
AND (
token = 'KAp8dn7CzyxXR3/VnyW8PsmtnMpoUTo+qn5BufjZ0C4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)