UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'FsCnHvrIvhuUF16WVKb2Es15UvonAPdyEmzI9a7br5Y=' 
WHERE 
  key_id = '9e5b99a030ca2ae1e012614edbbccc5cd8d98282d55e8526942e7afaa9a0f1aa' 
  AND (
    token = 'FsCnHvrIvhuUF16WVKb2Es15UvonAPdyEmzI9a7br5Y=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00034