UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'SSphW4WZ23zLpBLMkzTGW7K1Nnk4YaGUrlf08ZW1Eow=' 
WHERE 
  key_id = '4737cf9122ad4d9e5ff11ff03958950f683f5dc143136455a647a9eaeb94dc84' 
  AND (
    token = 'SSphW4WZ23zLpBLMkzTGW7K1Nnk4YaGUrlf08ZW1Eow=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00019