UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'zoG1hWN1CRCeKG+ZDu5Uaxijfs9qiJRPeNgQGcVjHP8=' 
WHERE 
  key_id = 'e590e87626c814cb9d57e87f515f3a17de0eb2c8dec8eb049bfd4e07678828db' 
  AND (
    token = 'zoG1hWN1CRCeKG+ZDu5Uaxijfs9qiJRPeNgQGcVjHP8=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00021