UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'MkHeisR3RvzYy75xvFPXV8Sy8uzRGrWM2bID8yvK5to=' 
WHERE 
  key_id = '8d699ef56f6f83a4c22c1e0be2c70712325f8b0e3cc4147278f9329811f5747b' 
  AND (
    token = 'MkHeisR3RvzYy75xvFPXV8Sy8uzRGrWM2bID8yvK5to=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00022