UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'IVIwDLYPi6XB97Bh6sHPv+U1Zef7z/z5Wo94LuhUTdY=' 
WHERE 
  key_id = '886f6d142f4bcb86c94f7a9a15f3403de48205d63e46b6e7cdb13d78c2696070' 
  AND (
    token = 'IVIwDLYPi6XB97Bh6sHPv+U1Zef7z/z5Wo94LuhUTdY=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00028