UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'sTOq9y1JVo6w8c7PdyKeH049Ok3mSV3dGBEbg5J0WOg=' 
WHERE 
  key_id = '1c9275b55cae909f48d471420ffcb52dace3a22223499e84f1d113805d2367f9' 
  AND (
    token = 'sTOq9y1JVo6w8c7PdyKeH049Ok3mSV3dGBEbg5J0WOg=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00066