UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wqnqCT7mjVhmluLg+/Nm1WtNJO7DPkYREve/uFmdEfQ='
WHERE
key_id = '52a493b959cc93f6389844c37453452e057d8e5a5463e9b70c32514491304c7a'
AND (
token = 'wqnqCT7mjVhmluLg+/Nm1WtNJO7DPkYREve/uFmdEfQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)