UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Pi5A10WigG2K+WX6AX5PMJqdA8tYPHKePvK6Q5ZzzYY=' 
WHERE 
  key_id = 'df98441ef67e4b3078d87a9279a01bd7f6041b261602a9e5c6883d99b9bcb6a6' 
  AND (
    token = 'Pi5A10WigG2K+WX6AX5PMJqdA8tYPHKePvK6Q5ZzzYY=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00051