UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'N+HtI6Y+n8uJHmni3KYb066eag4/6wgI9lVM+eHrYAY=' 
WHERE 
  key_id = '310e841e4b23bce9f2aa000d90a7a529ed84c2c45f785b04a857c0ece2c2f009' 
  AND (
    token = 'N+HtI6Y+n8uJHmni3KYb066eag4/6wgI9lVM+eHrYAY=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00035