UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3Ny0WZtUZn3HkVX8hsZx6kZ8rjk3b+dY6K3ftXfakvA='
WHERE
key_id = 'df065c1afb0b7a8ca4f811d7ce3725d2b3df703867673cf4cd5b332261cd44ff'
AND (
token = '3Ny0WZtUZn3HkVX8hsZx6kZ8rjk3b+dY6K3ftXfakvA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)