UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'mIhRMMXjiW+b1SkvnHjU9N40luE7vRpuVYqMWU+hXYQ=' 
WHERE 
  key_id = '207a4b92f4c7ce21a597762a8fb149acc7a03e476616d564e2ca3a0296e7f0ea' 
  AND (
    token = 'mIhRMMXjiW+b1SkvnHjU9N40luE7vRpuVYqMWU+hXYQ=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00019